﻿CREATE TABLE [flcrTM].[DEVICE_POWER] (
    [TM_DEVICE_POWER_ID]       INT           IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]                 INT           NOT NULL,
    [DEVICE_POWER_ID]          INT           NOT NULL,
    [AUDIT_USER]               VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]               DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]            INT           NOT NULL,
    [AUDIT_MOD_USER]           VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]           DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]        INT           NOT NULL,
    [DEVICE_PLATFORM_ID]       INT           NOT NULL,
    [POWER_UTIL_MEASURES_TYPE] INT           NOT NULL,
    [POWER_MAX_INPUT]          DECIMAL (18)  NOT NULL,
    [POWER_MAX_STANDBY]        DECIMAL (18)  NOT NULL,
    [HEAT_UTIL_MEASURES_TYPE]  INT           NOT NULL,
    [HEAT_MAX_DISSIPATION]     DECIMAL (18)  NOT NULL
);

